Excel Portable Genius by Lisa A. Bucki

Author:Lisa A. Bucki [Bucki, Lisa A.]
Language: eng
Format: epub
ISBN: 9781119763598
Publisher: Wiley
Published: 2020-12-10T00:00:00+00:00

Genius

You can use the Format Painter to copy number and cell formatting from one selection to another. Select the cells with the formatting to copy, choose Home ➔ Clipboard ➔ Format Painter, and then drag over the other cells to format. You also can double‐click the Format Painter button to lock it on, click or drag to copy the formatting to multiple other locations, and then press Esc or click the button again to turn off Format Painter.

Figure 5.11 shows a number of formatting selections from the Font and Alignment groups of the Home tab applied in an example worksheet, for a sense of the possibilities. Some of the changes are obvious, such as the fact that I applied a different font to the title and labels in the sheet and increased the font size for the title. I changed the font color for all the total values to green and all the average values to blue. I wrapped some titles, used a preset to rotate others, and applied both vertical and horizontal centering to offset some labels from the values below them. Finally, the left‐aligned text entries for the Bonus? column looked too crowded next to the right‐aligned values in the Average column, so I used the Increase Indent button to add just enough space to make the Bonus? column more clean and readable.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.